﻿CREATE PROCEDURE [dbo].[sp_public_getMemberEmail]
	@MemberId int,
	@MemberEmail nvarchar(100) OUTPUT
AS
	SELECT @MemberEmail = Member_Email FROM Members WHERE Member_Id = @MemberId
RETURN 0